Skip to main content
TrustRadius
Db2

Db2

Overview

What is Db2?

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

Read more
Recent Reviews

Db2 Review

9 out of 10
February 13, 2024
Incentivized
Db2 has been a critical component of our organization's data management strategy, delivering several advantages to satisfy our business …
Continue reading

DB2 review.

9 out of 10
February 07, 2024
Incentivized
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Db2 on Cloud Lite

$0

Cloud

Db2 on Cloud Standard

$99

Cloud
per month

Db2 Warehouse on Cloud Flex One

$898

Cloud
per month

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://www.ibm.com/products/db2/pricin…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is Db2?

IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.

From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.


Availability

Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.

Built-in security

Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.

Scalability

Db2 grows with users, scaling up and out as workloads evolve and performance needs change.

Automation

Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.


Db2 can be run in the cloud, on-premises, or in hybrid environments.
Free Trials available here: https://ibm.biz/BdSWMA

Db2 Integrations

Db2 Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, UNIX
Mobile ApplicationNo

Frequently Asked Questions

DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

Oracle Database, Microsoft SQL Server, and Google Cloud SQL are common alternatives for Db2.

Reviewers rate Performance highest, with a score of 9.1.

The most common users of Db2 are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(207)

Attribute Ratings

Reviews

(1-10 of 10)
Companies can't remove reviews or game the system. Here's why
Aman Makwana | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
IBM's Db2 is the most low latency enterprises database which supports for faster realtime as well as supporting low latency transactions equipped with full availability. Our use case for in order to use Db2 is to store all our banking related datas ( user data, bank/ATM branches data, Transaction purpose ), Assets inventory and some data of our own datalake which helds massive amount of data for showcasing analysis for various use cases.
  • Support for Integrations with Public cloud vendors
  • Rich Monitoring and Metrics so that a team can focus less on DB administration tasks and can focus more on Customer Experiences and Product Wellness, Queries monitoring/Indentification of slow queries, Query recommendations.
  • Database Scalability, Availability is very high
  • Migration Assistant so we can easily migrate the database from any platform to IBM DB2
  • Documentation needs bit attention as we have to find many things which can be found very easy
  • Good UI for monitoring, user can create own custom DB dashboards
Products which are at very high scale in Storage,traffic patterns, Live analysis, realtime streaming, Transactional workload. IBM's Db2 is a jack of all these above mentioned trades. IBM's Db2 is not suitable the very small scale workload as it is bit expensive.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
When we initially looked at Db2 the use case to drive adoption was geared towards control of large scale unstructured data which was sourced from many different sources integration methods. From that initial scope, you can image the workload and compute problems that you have in just extracting, loading, and running data quality processes on that data even before beginning to start to refine and curate for many different presentation layers. Db2 offers a wide range of integration support, has the agility to handle large scale enterprise workloads, and most import offers the flexibility of cloud compatibility.
  • Query optimization capabilities - algorithms drive analysis and optimization execution plans for basic to complicated complex queries
  • Security built with data design in mind - encryption, access controls, and auditing are fully baked in ready to use amongst many other security features
  • Disaster recovery and availability - replication, automatic failover, and failure secondary copy mode for critical workloads and increased uptime
  • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
  • Better resource utilization monitoring and recommendations
  • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
I could think of a couple but the obvious is in Fintech and Retail, because of the amount of transactional and event level data for global operations. It is imperative to have a solution that can handle such large scale date, in real-time and batch delivery for inbound and outbound delivery, and ultimately ensuring that workload management is supported in some cases for around the clock SLAs.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
After almost 4 years with Db2, I can confirm its reliability and accurateness and many features. As an illustration of its stability, it handles our situation with many transactions without issues and complaints. Also, due to its cross-platform interoperability, our efficiency increased, and we gained useful information. Finally, troubleshooting is very easy if any issue arises and can be solved very easily with detailed documentation and a helpful community.
  • Compatible with almost every 3rd party application, it is easier to link and integrate.
  • Very accurate and reliable. It has a reliable community and detailed documentation.
  • Has great data protection and security and robust backup options.
  • It is very difficult to setup or configure, even with the help of the documentation. So, make the setup process simpler.
  • The support takes quite some time to reply to our queries, which is sometimes frustrating.
  • There is nothing else that I see can be improved. Maybe a better UI or dashboard would be great.
Both end users and programmers benefit from its reliability, accuracy, and simplicity. It offers the best cloud database management choices, which are very reliable and have almost zero downtime. With it, you can easily handle surges and loads without affecting server or database availability.
February 07, 2024

DB2 review.

Score 9 out of 10
Vetted Review
Verified User
Incentivized
DB2 helps design, store, and handle large collections of data. DB2 provides both on-premises and cloud hosting solutions. DB2 can be fine-tuned to scale according to the load, improving performance. DB2 can handle structured, unstructured, and relational data on one platform itself.
  • Availability
  • Flexible scaling.
  • Security
  • UI functionality.
  • The cost is high.
  • Complicated queries.
DB2 is well suited for applications involving large amounts of data, like machine learning. DB2 provides API support for many languages.DB2 has an excellent compression feature. Not all applications work with the DB2 database. There are many new databases available currently that are faster in executing queries and have better UI experience.
Rohan Kumar | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Because Db2 is scalable, it can be used by both big and small businesses with different types of data requirements. To obtain data and test my applications using various data sets, I primarily utilize SQL scripts. The financial and demographic data that form the foundation of our system are ideal for the Db2 database. With all of our sensitive data, the system's security is ideal.
  • Reliability and Availability
  • It has Advanced Analytics
  • Security features are great
  • UI can be improved.
  • It has learning curve.
  • Less Integration options
IBM prioritizes availability and dependability in Db2, which makes it a strong option for applications that are mission-critical. Our business clients required a highly accessible database system that could grow with them easily. Although there were other possibilities, IBM Db2 offered smooth query execution and multi-cloud capabilities. This solution proved to be steadfast due to its potent performance and IBM Db2's dependability.
Rishabh Khanna | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is being used by our research and development department. We are working on improving our IoT based ERP system. We want our system to have multiple database integrations so IBM Db2 on Cloud is one of them. We are storing the machine-generated data which comes directly from [the] production site.
  • It is easy to understand
  • It is fully managed and highly available
  • It provides easy data migration
  • They should work on improving UI part
  • Documentation can be more helpful if they will add best practices section
It is a great product. It can be used by new as well as experienced developers to create a database instance without any assistance from DBA. We are using it with our IoT based ERP system. It can also be used by Analysts who want to build databases from scratch in no time.
Ejaz Hussain | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have been using IBM Db2 on Cloud as our development & testing database which is used across different projects spanning multiple clients. Our development teams make use of this fully managed database as a service solution to store critical test data and also to fetch data for multiple applications.
IBM Db2 on Cloud is a very robust and versatile solution [that] doesn't need any prior hard core db knowledge to use it, so this was a clear choice when deciding to opt for a seamless database solution.
  • Extremely easy data migration
  • Intuitive UI & easy to learn
  • Availability of auto backup feature
  • High service availability
  • Very less region options
  • Pricing model could be more flexible
  • More product documentation be made available
  • UI could be made more interactive with little bit of enhancement
We have been using IBM Db2 on Cloud solution for some time now and we absolutely like its features and functionality. This database is more suited for small & medium-level organizations. [It] can be used as a database for web and mobile applications.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are using DB2 as a primary database with one of our clients to store data generated by the GST software.
  • Reliable and fast
  • Easy to deploy and administer
  • Scalable as per the requirement
  • Micro options can be placed in more user intuitive interface
  • Documentation can be improved to include more information about micro options available in different menus in the UI
DB2 is best suited for the scenarios where you are already using the different products from the IBM ecosystem. It allows for easy integration between different tools.
Jay Padhya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Currently IBM Db2 on Cloud is used by our Department, and our organization used a multi-vendor database approach so it's not the only database on cloud we have. We are currently storing daily feeds from our car measurements on the Db2 and then pull data for reports.
  • Easy to learn, install and query - great support. IBM is extremely good in support whenever you have any type of questions. You will find no issues on learning the language and installing.
  • Amazing performance on big queries : Never had issues on performance and we have a big chunk of data to pull.
  • UI : the UI can be improved to a great extent. Ideally we would want to see the UI/UX to match with latest trends.
  • Limitation to a 15TB database size for any edition below than ES for on-prem. I am sure Cloud solves it, but falls in the same range as others (sometimes higher), making it maybe not the first one to go to.
A great product - would not shy away at all. It has some great features that makes it easy to read and write. Their on-memory technology for on-prem is good and overall it's user friendly with its approach. I even like the IBM product support team on helping out on our issues. There is massive community support over online bugs and seems like one of my best go to tools for Data Science.
June 27, 2018

DB2 easy access

Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are using DB2 in our IT department. It's used as a back-end tool and specifically, we highly leverage the DB2 client tool to connect to IBM IAccess to do data connections to feed other inventory tools.
  • DB2 provides a strong command line interface
  • Very resilient DB connection
  • Integrated very well with IBM product
  • Maybe they could have a simple UI interface similar to MSSQL management studio
Database integration is very well suited since we have multiple connections from the DB2 connection tool to an AS400 system. It is working very well with IAccess and lets us integrate with our Windows server to provide a simple connection to an ODBC type connection to third-party tools and other databases like Domino.
Return to navigation